﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using NetWing.Common.Data.SqlServer;

namespace NetWing.BPM.Admin.mjprint
{
    public partial class tyyjsj : System.Web.UI.Page
    {
        public string edNumber = "";
        public DataRow dr = null;
        public DataRow depDr = null;
        public DataRow yyDr = null;
        protected void Page_Load(object sender, EventArgs e)
        {
            edNumber = Request["edNumber"];
            if (!string.IsNullOrEmpty(edNumber))
            {
                string sql = "select top 1 * from MJFinanceDetail where ednumber='" + edNumber + "' order by keyid desc";
                string yysql = "select top 1 * from nw_customform_user_MakeRoom where ednumber='" + edNumber + "' order by keyid desc";
                yyDr = SqlEasy.ExecuteDataRow(yysql);

                dr = SqlEasy.ExecuteDataRow(sql);
                depDr = SqlEasy.ExecuteDataRow("select * from Sys_Departments where keyid=" + dr["depid"].ToString() + "");


            }
        }
    }
}